View INSERTs not returning OID in Postgres 7.2.1
От | Damon Cokenias |
---|---|
Тема | View INSERTs not returning OID in Postgres 7.2.1 |
Дата | |
Msg-id | p04310112b8da5fa05391@[10.0.1.9] обсуждение исходный текст |
Ответ на | Re: Yet another indexing issue. (Stephan Szabo <sszabo@megazone23.bigpanda.com>) |
Ответы |
Re: View INSERTs not returning OID in Postgres 7.2.1
|
Список | pgsql-general |
I recently moved from 7.1.3 to 7.2.1. In doing so, my application broke. It relies on INSERT returning the OID of the insertedrow, even if the INSERT was on a view. I saw a note in the 7.2.1 notes about fixing a problem in this area, perhapsmore needs to be done? Example: acropolis=# create table shad (a integer); CREATE acropolis=# create view shadview as select * from shad; CREATE acropolis=# create rule shadview_insert as on insert to shadview do instead insert into shad values (new.a); CREATE acropolis=# insert into shad values (1); INSERT 3876425 1 acropolis=# insert into shadview values (2); INSERT 0 0 acropolis=# select * from shad; a --- 1 2 (2 rows) --------------- Shouldn't the second INSERT return an OID as well? Thanks, -Damon
В списке pgsql-general по дате отправления: